MySQL Lab Work

📥 Download Lab Work Template 📥 Download HandWritten

Question 9

Screenshot 1
select * from stud_info;

Question 10

Screenshot 2
select * from stud_info where Address='LALITPUR';

Question 11

Screenshot 3
select * from stud_info where Gender='F';

Question 12

Screenshot 4
select * from stud_info where Gender='M' And Address='KATHMANDU';

Question 13

Screenshot 5
select * from stud_info where Address='BHAKTAPUR' OR Address='KATHMANDU' ;

Question 14

Screenshot 6
select * from stud_info where Name Like 'R%';

Question 15

Screenshot 7
select * from stud_info where RegNo <= 77008 And RegNo >=77004;

Question 16

Screenshot 8
select * from stud_info where name like '%A';

Question 17

Screenshot 9
select * from stud_info where year(Dob)='2002' ;

Question 18

Screenshot 10
select * from stud_info where year(Dob)='2003' and month(Dob)='03';

Question 19

Screenshot 11
select Regno, name, year(sysdate())-year(Dob) AS Age from stud_info;

Question 20

Screenshot 12
select RegNo, name, year(sysdate())-year(Dob) AS Age from stud_info where year(sysdate())-year(Dob) <= 18 ;

Question 21

Screenshot 13
select * from stud_info where Address='KATHMANDU' And year(Dob)='2002' ;

Question 22

Screenshot 14
select * from stud_info where name like '_A%';

Question 23

Screenshot 15
select * from stud_info where Gender='F' and year(Dob)='2003' ;

Question 24

Screenshot 16
select *, year(sysdate())-year(Dob) AS Age from stud_info where year(sysdate())-year(Dob) >= 19 and Gender='M' ;